

alter trigger [tb_mnfexpenditure_bd] on [dbo].[tb_mnfexpenditure] instead of delete
as
begin
  delete from tb_mnfexpendituredtl where exists (select * from deleted where tb_mnfexpendituredtl.bid=deleted.bid)
  delete from tb_mnfexpenditure where exists (select * from deleted where tb_mnfexpenditure.bid=deleted.bid)
end



